﻿CREATE PROCEDURE [dbo].[proc_ProjectExpenditure_Item_GetItem]
	(
		@PEId uniqueidentifier
	)
AS
	Select 
		Id,
		PEItemId,
		PEId,
		PayItem,
		ComeInUnit,
		PlanPayDate,
		Moneydues,
		IsNull(PracticalPayDate,'1900-01-01') as PracticalPayDate,
		IsNull(PayAmount,0) as PayAmount,
		IsNull(ComeInPerson,'...') as ComeInPerson,
		IsNull(ComeInDate,'1900-01-01') as ComeInDate
	 From ProjectExpenditure_Item Where PEId = @PEId
	
	RETURN
